﻿-- Возврашает параметри процедур
CREATE PROCEDURE [dbo].[USPTOOLST_PFGetParamInProcedure]
	@Proc_Name [varchar](255)
WITH EXECUTE AS CALLER
AS
select Specific_Name as 'Procedure_Name', Parameter_Name, Ordinal_Position as 'Param_Position',  case Parameter_Mode when 'IN' then 'Input' else 'Output' end as 'Mode', Data_Type, Character_Maximum_Length 'Data_Length'
from information_schema.Parameters where specific_name = @Proc_Name


